17. Design and Create a Database

Design and CREATE a database

Question:

Start Quiz:

Solution:

Solution

image

Explanation

CREATE TABLE

SQL keywords used to create a new table

pets

Refers to the name of the table to be created

(_id INTEGER, name TEXT, breed TEXT, gender INTEGER, weight INTEGER);

In parenthesis is the list defining each column in the table and its corresponding data type. Remember to end the command with a semi-colon.

Next Concept